﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$SyrinxDBConnection$" formatter="bizobj of TreeNode">
	<Sql>
		SELECT
		t.id, t.parentHostId, t.parentId, c.rootId, c.keyName, c.name, c.depth
		FROM
		ObjectTreeNodes as t
		LEFT OUTER JOIN ObjectTreeCounts as c on c.objectId = t.objectId
		WHERE
		t.objectId=@parentId AND parentHostId=@parentId
	</Sql>
	<Param name="parentId" type="UniqueIdentifier"/>
</AdoNetDataAccess>